# -*- coding: utf-8 -*-

import MySQLdb


conn = MySQLdb.connect(host="101.200.216.183",user="root",passwd="liuyang",port=3306)
conn.select_db('tbkcms')

def insertGoods():
    cur = conn.cursor()
    #cur.execute("insert into t_article(`title`,`img`,`content`) values(%s,%s,%s)",(title,img,content))
    sql = "insert into sp_goods "
  num_iid,
  title,
  sort_id,
  tid,
  goods_type,
  provcity,
  nick,
  add_id,
  add_uname,
  seller_credit,
  discount_price,
  price,
  volume,
  comment_count,
  pic_url,
  item_url,
  click_url,
  shop_url,
  sclick_url,
  item_body,
  state,
  seo_title,
  seo_keywords,
  seo_description,
  ctime,
  hits,
  favor,
  order,
    conn.commit()
    cur.close()

